Dataset info
| Number of variables | 18 |
|---|---|
| Number of observations | 303464 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 22 (< 0.1%) |
| Total size in memory | 41.7 MiB |
| Average record size in memory | 144.0 B |
Variables types
| Numeric | 6 |
|---|---|
| Categorical | 9 |
| Boolean | 3 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
| Dataset has 22 (< 0.1%) duplicate rows | Warning |
DAY_OF_WEEK has 46081 (15.2%) zeros | Zeros |
INCIDENT_NUMBER has a high cardinality: 269610 distinct values | Warning |
Lat is highly skewed (γ1 = -44.0018857) | Skewed |
Location has a high cardinality: 17855 distinct values | Warning |
Long is highly skewed (γ1 = 44.04828979) | Skewed |
OCCURRED_ON_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
OCCURRED_ON_DATE has a high cardinality: 223126 distinct values | Warning |
OFFENSE_CODE_GROUP has 7406 (2.4%) zeros | Zeros |
OFFENSE_DESCRIPTION has a high cardinality: 226 distinct values | Warning |
REPORTING_AREA has a high cardinality: 880 distinct values | Warning |
STREET has a high cardinality: 3877 distinct values | Warning |
DAY_OF_WEEK
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.994697888 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros (%) | 15.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 2.031971181 |
|---|---|
| Coef of variation | 0.6785229285 |
| Kurtosis | -1.292929697 |
| Mean | 2.994697888 |
| MAD | 1.759870814 |
| Skewness | -0.00552037714 |
| Sum | 908783 |
| Variance | 4.128906881 |
| Memory size | 2.3 MiB |
Histogram with fixed size bins (bins=7)
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5.5 6. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 46081 | 15.2% | |
| 6 | 44588 | 14.7% | |
| 4 | 44222 | 14.6% | |
| 5 | 44067 | 14.5% | |
| 1 | 43491 | 14.3% | |
| 2 | 42504 | 14.0% | |
| 3 | 38511 | 12.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46081 | 15.2% | |
| 1 | 43491 | 14.3% | |
| 2 | 42504 | 14.0% | |
| 3 | 38511 | 12.7% | |
| 4 | 44222 | 14.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6 | 44588 | 14.7% | |
| 5 | 44067 | 14.5% | |
| 4 | 44222 | 14.6% | |
| 3 | 38511 | 12.7% | |
| 2 | 42504 | 14.0% |
DISTRICT
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| B2 | |
|---|---|
| C11 | |
| D4 | |
| Other values (9) |
| Value | Count | Frequency (%) | |
| B2 | 47072 | 15.5% | |
| C11 | 41768 | 13.8% | |
| D4 | 39406 | 13.0% | |
| B3 | 34412 | 11.3% | |
| A1 | 32652 | 10.8% | |
| C6 | 22384 | 7.4% | |
| D14 | 19531 | 6.4% | |
| E18 | 17010 | 5.6% | |
| E13 | 16874 | 5.6% | |
| E5 | 13053 | 4.3% | |
| Other values (2) | 19302 | 6.4% |
| Max length | 3 |
|---|---|
| Mean length | 2.334408694 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
HOUR
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Night | |
|---|---|
| Afternoon | |
| Morning | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| Night | 67681 | 22.3% | |
| Afternoon | 66223 | 21.8% | |
| Morning | 58230 | 19.2% | |
| Evening | 57397 | 18.9% | |
| Early Morning | 53933 | 17.8% |
| Max length | 13 |
|---|---|
| Mean length | 8.056738196 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
INCIDENT_NUMBER
Categorical
| Distinct count | 269610 |
|---|---|
| Unique (%) | 88.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| I162030584 | 12 |
|---|---|
| I152080623 | 11 |
| I172096394 | 10 |
| Other values (269607) |
| Value | Count | Frequency (%) | |
| I162030584 | 12 | < 0.1% | |
| I152080623 | 11 | < 0.1% | |
| I172096394 | 10 | < 0.1% | |
| I182065208 | 10 | < 0.1% | |
| I172013170 | 10 | < 0.1% | |
| I162001871 | 9 | < 0.1% | |
| I162098170 | 9 | < 0.1% | |
| I162071327 | 9 | < 0.1% | |
| I172053616 | 8 | < 0.1% | |
| I172056883 | 8 | < 0.1% | |
| Other values (269600) | 303368 | > 99.9% |
| Max length | 13 |
|---|---|
| Mean length | 10.00317995 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Lat
Numeric
| Distinct count | 17842 |
|---|---|
| Unique (%) | 5.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42.30001635 |
|---|---|
| Minimum | -1 |
| Maximum | 42.39504158 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 42.2686423 |
| Q1 | 42.29753608 |
| Median | 42.32560048 |
| Q3 | 42.34862382 |
| 95-th percentile | 42.3721588 |
| Maximum | 42.39504158 |
| Range | 43.39504158 |
| Interquartile range | 0.05108774 |
Descriptive statistics
| Standard deviation | 0.9825122047 |
|---|---|
| Coef of variation | 0.0232272299 |
| Kurtosis | 1936.22347 |
| Mean | 42.30001635 |
| MAD | 0.0548615579 |
| Skewness | -44.0018857 |
| Sum | 12836532.16 |
| Variance | 0.9653302324 |
| Memory size | 2.3 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-1. 20.61620665 42.23253443 42.23478927 42.23493284 ... 42.39308545 42.39350021 42.39380075 42.39462729 42.39504158], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 42.34862382 | 1275 | 0.4% | |
| 42.36183857 | 1248 | 0.4% | |
| 42.28482577 | 1136 | 0.4% | |
| 42.32866284 | 1075 | 0.4% | |
| 42.25621592 | 916 | 0.3% | |
| 42.29755533 | 792 | 0.3% | |
| 42.34128751 | 786 | 0.3% | |
| 42.33152148 | 758 | 0.2% | |
| 42.3523119 | 707 | 0.2% | |
| 42.33954199 | 667 | 0.2% | |
| Other values (17832) | 294104 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1 | 156 | 0.1% | |
| 42.2324133 | 10 | < 0.1% | |
| 42.23265556 | 2 | < 0.1% | |
| 42.23287025 | 5 | < 0.1% | |
| 42.23290729 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 42.39504158 | 29 | < 0.1% | |
| 42.394213 | 8 | < 0.1% | |
| 42.39407288 | 2 | < 0.1% | |
| 42.39352862 | 78 | < 0.1% | |
| 42.393518 | 13 | < 0.1% |
Location
Categorical
| Distinct count | 17855 |
|---|---|
| Unique (%) | 5.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| (42.34862382, -71.08277637) | 1275 |
|---|---|
| (42.36183857, -71.05976489) | 1248 |
| (42.28482577, -71.09137369) | 1136 |
| Other values (17852) |
| Value | Count | Frequency (%) | |
| (42.34862382, -71.08277637) | 1275 | 0.4% | |
| (42.36183857, -71.05976489) | 1248 | 0.4% | |
| (42.28482577, -71.09137369) | 1136 | 0.4% | |
| (42.32866284, -71.08563401) | 1075 | 0.4% | |
| (42.25621592, -71.12401947) | 916 | 0.3% | |
| (42.29755533, -71.05970910) | 792 | 0.3% | |
| (42.34128751, -71.05467933) | 786 | 0.3% | |
| (42.33152148, -71.07085307) | 758 | 0.2% | |
| (42.35231190, -71.06370510) | 707 | 0.2% | |
| (42.33954199, -71.06940877) | 667 | 0.2% | |
| Other values (17845) | 294104 | 96.9% |
| Max length | 27 |
|---|---|
| Mean length | 26.99948594 |
| Min length | 26 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Long
Numeric
| Distinct count | 17840 |
|---|---|
| Unique (%) | 5.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -71.0468408 |
|---|---|
| Minimum | -71.17867378 |
| Maximum | -1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -71.17867378 |
|---|---|
| 5-th percentile | -71.14406047 |
| Q1 | -71.09719984 |
| Median | -71.077549 |
| Q3 | -71.06253785 |
| 95-th percentile | -71.04011349 |
| Maximum | -1 |
| Range | 70.17867378 |
| Interquartile range | 0.03466199 |
Descriptive statistics
| Standard deviation | 1.588861256 |
|---|---|
| Coef of variation | -0.02236357364 |
| Kurtosis | 1938.948656 |
| Mean | -71.0468408 |
| MAD | 0.0737725392 |
| Skewness | 44.04828979 |
| Sum | -21560158.5 |
| Variance | 2.524480091 |
| Memory size | 2.3 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-71.17867378 -71.17436122 -71.17293107 -71.17283216 -71.17246628 ... -70.99640418 -70.99570006 -70.96402052 -35.98183807 -1. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -71.08277637 | 1275 | 0.4% | |
| -71.05976489 | 1248 | 0.4% | |
| -71.09137369 | 1136 | 0.4% | |
| -71.08563401 | 1075 | 0.4% | |
| -71.12401947 | 916 | 0.3% | |
| -71.0597091 | 792 | 0.3% | |
| -71.05467933 | 786 | 0.3% | |
| -71.07085307 | 758 | 0.2% | |
| -71.0637051 | 707 | 0.2% | |
| -71.06940877 | 667 | 0.2% | |
| Other values (17830) | 294104 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -71.17867378 | 20 | < 0.1% | |
| -71.17745696 | 4 | < 0.1% | |
| -71.17680515 | 24 | < 0.1% | |
| -71.17563839 | 3 | < 0.1% | |
| -71.17519031 | 10 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -1 | 156 | 0.1% | |
| -70.96367615 | 1 | < 0.1% | |
| -70.96436489 | 3 | < 0.1% | |
| -70.99536185 | 2 | < 0.1% | |
| -70.99603826 | 4 | < 0.1% |
MONTH
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.67388883 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| Median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 3.259566671 |
|---|---|
| Coef of variation | 0.4884058986 |
| Kurtosis | -1.037546069 |
| Mean | 6.67388883 |
| MAD | 2.767255378 |
| Skewness | -0.1199037798 |
| Sum | 2025285 |
| Variance | 10.62477488 |
| Memory size | 2.3 MiB |
Histogram with fixed size bins (bins=12)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 4.5 5.5 ... 8.5 9.5 10.5 11.5 12. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 8 | 32359 | 10.7% | |
| 7 | 32011 | 10.5% | |
| 9 | 31401 | 10.3% | |
| 6 | 28439 | 9.4% | |
| 10 | 24447 | 8.1% | |
| 5 | 24175 | 8.0% | |
| 4 | 22346 | 7.4% | |
| 3 | 22201 | 7.3% | |
| 1 | 22104 | 7.3% | |
| 11 | 22025 | 7.3% | |
| Other values (2) | 41956 | 13.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 22104 | 7.3% | |
| 2 | 20009 | 6.6% | |
| 3 | 22201 | 7.3% | |
| 4 | 22346 | 7.4% | |
| 5 | 24175 | 8.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12 | 21947 | 7.2% | |
| 11 | 22025 | 7.3% | |
| 10 | 24447 | 8.1% | |
| 9 | 31401 | 10.3% | |
| 8 | 32359 | 10.7% |
OCCURRED_ON_DATE
Categorical
| Distinct count | 223126 |
|---|---|
| Unique (%) | 73.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2017-01-06 00:00:00 | 27 |
|---|---|
| 2015-01-07 00:00:00 | 26 |
| 2016-01-08 00:00:00 | 25 |
| Other values (223123) |
| Value | Count | Frequency (%) | |
| 2017-01-06 00:00:00 | 27 | < 0.1% | |
| 2015-01-07 00:00:00 | 26 | < 0.1% | |
| 2016-01-08 00:00:00 | 25 | < 0.1% | |
| 2017-01-01 00:00:00 | 21 | < 0.1% | |
| 2017-01-05 00:00:00 | 20 | < 0.1% | |
| 2016-01-04 00:00:00 | 19 | < 0.1% | |
| 2017-01-08 00:00:00 | 19 | < 0.1% | |
| 2017-01-04 00:00:00 | 19 | < 0.1% | |
| 2015-07-12 11:38:00 | 19 | < 0.1% | |
| 2018-01-01 00:00:00 | 18 | < 0.1% | |
| Other values (223116) | 303251 | 99.9% |
| Max length | 19 |
|---|---|
| Mean length | 19 |
| Min length | 19 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
OFFENSE_CODE
Numeric
| Distinct count | 207 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2300.197829 |
|---|---|
| Minimum | 111 |
| Maximum | 3831 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 522 |
| Q1 | 1001 |
| Median | 2907 |
| Q3 | 3201 |
| 95-th percentile | 3830 |
| Maximum | 3831 |
| Range | 3720 |
| Interquartile range | 2200 |
Descriptive statistics
| Standard deviation | 1180.961393 |
|---|---|
| Coef of variation | 0.513417315 |
| Kurtosis | -1.432345602 |
| Mean | 2300.197829 |
| MAD | 1084.429775 |
| Skewness | -0.4035875544 |
| Sum | 698027234 |
| Variance | 1394669.813 |
| Memory size | 2.3 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 111. 206. 306. 313. 350. ... 3815.5 3820.5 3825.5 3830.5 3831. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3006 | 18385 | 6.1% | |
| 3115 | 18379 | 6.1% | |
| 1402 | 14978 | 4.9% | |
| 3831 | 14724 | 4.9% | |
| 802 | 14252 | 4.7% | |
| 3301 | 13321 | 4.4% | |
| 3410 | 11061 | 3.6% | |
| 3114 | 10893 | 3.6% | |
| 617 | 9122 | 3.0% | |
| 2647 | 9083 | 3.0% | |
| Other values (197) | 169266 | 55.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 111 | 152 | 0.1% | |
| 301 | 2766 | 0.9% | |
| 311 | 566 | 0.2% | |
| 315 | 1 | < 0.1% | |
| 335 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3831 | 14724 | 4.9% | |
| 3830 | 1038 | 0.3% | |
| 3821 | 318 | 0.1% | |
| 3820 | 1333 | 0.4% | |
| 3811 | 323 | 0.1% |
OFFENSE_CODE_GROUP
Numeric
| Distinct count | 59 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 34.27311642 |
|---|---|
| Minimum | 0 |
| Maximum | 58 |
| Zeros (%) | 2.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 25 |
| Median | 34 |
| Q3 | 48 |
| 95-th percentile | 56 |
| Maximum | 58 |
| Range | 58 |
| Interquartile range | 23 |
Descriptive statistics
| Standard deviation | 15.27891704 |
|---|---|
| Coef of variation | 0.4457988836 |
| Kurtosis | -0.638430209 |
| Mean | 34.27311642 |
| MAD | 12.29294932 |
| Skewness | -0.2082530287 |
| Sum | 10400657 |
| Variance | 233.4453058 |
| Memory size | 2.3 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 54.5 55.5 56.5 57.5 58. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 35 | 31186 | 10.3% | |
| 27 | 25808 | 8.5% | |
| 32 | 23041 | 7.6% | |
| 24 | 18379 | 6.1% | |
| 38 | 17482 | 5.8% | |
| 53 | 15264 | 5.0% | |
| 55 | 15234 | 5.0% | |
| 12 | 14829 | 4.9% | |
| 56 | 13321 | 4.4% | |
| 54 | 11061 | 3.6% | |
| Other values (49) | 117859 | 38.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 7406 | 2.4% | |
| 1 | 31 | < 0.1% | |
| 2 | 932 | 0.3% | |
| 3 | 4598 | 1.5% | |
| 4 | 961 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 58 | 7682 | 2.5% | |
| 57 | 5103 | 1.7% | |
| 56 | 13321 | 4.4% | |
| 55 | 15234 | 5.0% | |
| 54 | 11061 | 3.6% |
OFFENSE_DESCRIPTION
Categorical
| Distinct count | 226 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| SICK/INJURED/MEDICAL - PERSON | 18385 |
|---|---|
| INVESTIGATE PERSON | 18379 |
| VANDALISM | 14978 |
| Other values (223) |
| Value | Count | Frequency (%) | |
| SICK/INJURED/MEDICAL - PERSON | 18385 | 6.1% | |
| INVESTIGATE PERSON | 18379 | 6.1% | |
| VANDALISM | 14978 | 4.9% | |
| M/V - LEAVING SCENE - PROPERTY DAMAGE | 14724 | 4.9% | |
| ASSAULT SIMPLE - BATTERY | 14244 | 4.7% | |
| VERBAL DISPUTE | 13321 | 4.4% | |
| TOWED MOTOR VEHICLE | 11061 | 3.6% | |
| INVESTIGATE PROPERTY | 10893 | 3.6% | |
| LARCENY THEFT FROM BUILDING | 9118 | 3.0% | |
| THREATS TO DO BODILY HARM | 9083 | 3.0% | |
| Other values (216) | 169278 | 55.8% |
| Max length | 49 |
|---|---|
| Mean length | 23.87816347 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
REPORTING_AREA
Categorical
| Distinct count | 880 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 111 | 2395 |
|---|---|
| 329 | 1915 |
| 117 | 1882 |
| Other values (877) |
| Value | Count | Frequency (%) | |
| 111 | 2395 | 0.8% | |
| 329 | 1915 | 0.6% | |
| 117 | 1882 | 0.6% | |
| 186 | 1845 | 0.6% | |
| 143 | 1821 | 0.6% | |
| 624 | 1806 | 0.6% | |
| 26 | 1773 | 0.6% | |
| 465 | 1710 | 0.6% | |
| 130 | 1444 | 0.5% | |
| 427 | 1428 | 0.5% | |
| Other values (870) | 285445 | 94.1% |
| Max length | 3 |
|---|---|
| Mean length | 2.891766404 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
STREET
Categorical
| Distinct count | 3877 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| WASHINGTON ST | 14204 |
|---|---|
| BLUE HILL AVE | 7125 |
| BOYLSTON ST | 7119 |
| Other values (3874) |
| Value | Count | Frequency (%) | |
| WASHINGTON ST | 14204 | 4.7% | |
| BLUE HILL AVE | 7125 | 2.3% | |
| BOYLSTON ST | 7119 | 2.3% | |
| DORCHESTER AVE | 5125 | 1.7% | |
| TREMONT ST | 4774 | 1.6% | |
| HARRISON AVE | 4503 | 1.5% | |
| MASSACHUSETTS AVE | 4501 | 1.5% | |
| CENTRE ST | 4374 | 1.4% | |
| COMMONWEALTH AVE | 3992 | 1.3% | |
| HYDE PARK AVE | 3491 | 1.2% | |
| Other values (3867) | 244256 | 80.5% |
| Max length | 25 |
|---|---|
| Mean length | 11.14718715 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
UCR_Part_One
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 243213 | 80.1% | |
| 1 | 60251 | 19.9% |
UCR_Part_Three
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 153318 | 50.5% | |
| 1 | 150146 | 49.5% |
UCR_Part_Two
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 210397 | 69.3% | |
| 1 | 93067 | 30.7% |
YEAR
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2017 | |
|---|---|
| 2016 | |
| 2018 |
| Value | Count | Frequency (%) | |
| 2017 | 92727 | 30.6% | |
| 2016 | 91182 | 30.0% | |
| 2018 | 68469 | 22.6% | |
| 2015 | 51086 | 16.8% |
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
First rows
| DAY_OF_WEEK | DISTRICT | HOUR | INCIDENT_NUMBER | Lat | Location | Long | MONTH | OCCURRED_ON_DATE | OFFENSE_CODE | OFFENSE_CODE_GROUP | OFFENSE_DESCRIPTION | REPORTING_AREA | STREET | UCR_Part_One | UCR_Part_Three | UCR_Part_Two | YEAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 6 | E18 | Night | I182080058 | 42.262608 | (42.26260773, -71.12118637) | -71.121186 | 10 | 2018-03-10 20:13:00 | 2403 | 11 | DISTURBING THE PEACE | 495 | ARLINGTON ST | 0 | 0 | 1 | 2018 |
| 1 | 4 | D14 | Night | I182080053 | 42.352111 | (42.35211146, -71.13531147) | -71.135311 | 8 | 2018-08-30 20:00:00 | 3201 | 44 | PROPERTY - LOST | 795 | ALLSTON ST | 0 | 1 | 0 | 2018 |
| 2 | 6 | B2 | Night | I182080052 | 42.308126 | (42.30812619, -71.07692974) | -71.076930 | 10 | 2018-03-10 19:20:00 | 2647 | 38 | THREATS TO DO BODILY HARM | 329 | DEVON ST | 0 | 0 | 1 | 2018 |
| 3 | 6 | A1 | Night | I182080051 | 42.359454 | (42.35945371, -71.05964817) | -71.059648 | 10 | 2018-03-10 20:00:00 | 413 | 0 | ASSAULT - AGGRAVATED - BATTERY | 92 | CAMBRIDGE ST | 1 | 0 | 0 | 2018 |
| 4 | 6 | A7 | Night | I182080050 | 42.375258 | (42.37525782, -71.02466343) | -71.024663 | 10 | 2018-03-10 20:49:00 | 3122 | 1 | AIRCRAFT INCIDENTS | 36 | PRESCOTT ST | 0 | 1 | 0 | 2018 |
| 5 | 5 | C11 | Night | I182080049 | 42.299197 | (42.29919694, -71.06046974) | -71.060470 | 10 | 2018-02-10 20:40:00 | 1402 | 55 | VANDALISM | 351 | DORCHESTER AVE | 0 | 0 | 1 | 2018 |
| 6 | 6 | B2 | Night | I182080047 | 42.333807 | (42.33380683, -71.10377843) | -71.103778 | 10 | 2018-03-10 19:32:00 | 3301 | 56 | VERBAL DISPUTE | 603 | TREMONT ST | 0 | 1 | 0 | 2018 |
| 7 | 6 | E18 | Night | I182080045 | 42.256145 | (42.25614494, -71.12802506) | -71.128025 | 10 | 2018-03-10 19:27:00 | 802 | 53 | ASSAULT SIMPLE - BATTERY | 543 | AVILA RD | 0 | 0 | 1 | 2018 |
| 8 | 6 | D4 | Night | I182080044 | 42.348866 | (42.34886600, -71.08936284) | -71.089363 | 10 | 2018-03-10 20:00:00 | 3410 | 54 | TOWED MOTOR VEHICLE | 621 | COMMONWEALTH AVE | 0 | 1 | 0 | 2018 |
| 9 | 6 | D14 | Night | I182080043 | 42.344323 | (42.34432328, -71.15778368) | -71.157784 | 10 | 2018-03-10 19:33:00 | 3803 | 35 | M/V ACCIDENT - PERSONAL INJURY | 750 | FOSTER ST | 0 | 1 | 0 | 2018 |
Last rows
| DAY_OF_WEEK | DISTRICT | HOUR | INCIDENT_NUMBER | Lat | Location | Long | MONTH | OCCURRED_ON_DATE | OFFENSE_CODE | OFFENSE_CODE_GROUP | OFFENSE_DESCRIPTION | REPORTING_AREA | STREET | UCR_Part_One | UCR_Part_Three | UCR_Part_Two | YEAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 303454 | 6 | A1 | Afternoon | I080542626-00 | 42.352312 | (42.35231190, -71.06370510) | -71.063705 | 8 | 2015-12-08 12:00:00 | 3125 | 58 | WARRANT ARREST | 111 | BOYLSTON ST | 0 | 1 | 0 | 2015 |
| 303455 | 6 | A1 | Afternoon | I080542626-00 | 42.352312 | (42.35231190, -71.06370510) | -71.063705 | 8 | 2015-12-08 12:00:00 | 1848 | 12 | DRUGS - POSS CLASS B - INTENT TO MFR DIST DISP | 111 | BOYLSTON ST | 0 | 0 | 1 | 2015 |
| 303456 | 6 | A1 | Afternoon | I080542626-00 | 42.352312 | (42.35231190, -71.06370510) | -71.063705 | 8 | 2015-12-08 12:00:00 | 1849 | 12 | DRUGS - POSS CLASS B - COCAINE, ETC. | 111 | BOYLSTON ST | 0 | 0 | 1 | 2015 |
| 303457 | 2 | E13 | Afternoon | I060168073-00 | 42.322838 | (42.32283759, -71.10096723) | -71.100967 | 1 | 2018-01-27 14:01:00 | 1864 | 12 | DRUGS - POSS CLASS D - INTENT MFR DIST DISP | 912 | CENTRE ST | 0 | 0 | 1 | 2018 |
| 303458 | 2 | E13 | Afternoon | I060168073-00 | 42.322838 | (42.32283759, -71.10096723) | -71.100967 | 1 | 2018-01-27 14:01:00 | 3125 | 58 | WARRANT ARREST | 912 | CENTRE ST | 0 | 1 | 0 | 2018 |
| 303459 | 3 | D4 | Evening | I050310906-00 | 42.336951 | (42.33695098, -71.08574813) | -71.085748 | 6 | 2016-05-06 17:25:00 | 3125 | 58 | WARRANT ARREST | 285 | COVENTRY ST | 0 | 1 | 0 | 2016 |
| 303460 | 4 | E18 | Afternoon | I030217815-08 | 42.255926 | (42.25592648, -71.12317207) | -71.123172 | 7 | 2015-09-07 13:38:00 | 111 | 23 | MURDER, NON-NEGLIGIENT MANSLAUGHTER | 520 | RIVER ST | 1 | 0 | 0 | 2015 |
| 303461 | 4 | E18 | Afternoon | I030217815-08 | 42.255926 | (42.25592648, -71.12317207) | -71.123172 | 7 | 2015-09-07 13:38:00 | 3125 | 58 | WARRANT ARREST | 520 | RIVER ST | 0 | 1 | 0 | 2015 |
| 303462 | 5 | E13 | Night | I010370257-00 | 42.302333 | (42.30233307, -71.11156487) | -71.111565 | 5 | 2016-05-31 19:35:00 | 3125 | 58 | WARRANT ARREST | 569 | NEW WASHINGTON ST | 0 | 1 | 0 | 2016 |
| 303463 | 1 | D4 | Early Morning | 142052550 | 42.333839 | (42.33383935, -71.08029038) | -71.080290 | 6 | 2015-06-22 00:12:00 | 3125 | 58 | WARRANT ARREST | 903 | WASHINGTON ST | 0 | 1 | 0 | 2015 |